Tabela DoctorDiagnosis

Definicja tabeli DoctorDiagnosis

Name

DoctorDiagnosis

Code

DoctorDiagnosis

Comment

Opisowe diagnozy lekarskie.


Lista kolumn tabeli DoctorDiagnosis

Name

Code

DoctorDiagnosisID

DoctorDiagnosisID

EventID

EventID

DescriptiveDataID

DescriptiveDataID

LEventICDID

LEventICDID

DiagnosisTypeID

DiagnosisTypeID

DiagnosisKindID

DiagnosisKindID

LPersonICDID

LPersonICDID


Kolumna DoctorDiagnosisID tabeli DoctorDiagnosis

Definicja kolumny DoctorDiagnosisID tabeli DoctorDiagnosis

Name

DoctorDiagnosisID

Code

DoctorDiagnosisID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli DoctorDiagnosis

Definicja kolumny EventID tabeli DoctorDiagnosis

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DescriptiveDataID tabeli DoctorDiagnosis

Definicja kolumny DescriptiveDataID tabeli DoctorDiagnosis

Name

DescriptiveDataID

Code

DescriptiveDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LEventICDID tabeli DoctorDiagnosis

Definicja kolumny LEventICDID tabeli DoctorDiagnosis

Name

LEventICDID

Code

LEventICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DiagnosisTypeID tabeli DoctorDiagnosis

Definicja kolumny DiagnosisTypeID tabeli DoctorDiagnosis

Name

DiagnosisTypeID

Code

DiagnosisTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DiagnosisKindID tabeli DoctorDiagnosis

Definicja kolumny DiagnosisKindID tabeli DoctorDiagnosis

Name

DiagnosisKindID

Code

DiagnosisKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LPersonICDID tabeli DoctorDiagnosis

Definicja kolumny LPersonICDID tabeli DoctorDiagnosis

Name

LPersonICDID

Code

LPersonICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli DoctorDiagnosis

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DoctorDiagnosis

Definicja klucza Identifier_1 tabeli DoctorDiagnosis

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment